package edu.example.check.utils;

public class ReSqlUtils {
    public static String deleteUser() {
        return "delete from user where stucode = ?";
    }

    public static String deleteBuilds() {
        return "delete from buildings where buildingid = ?";
    }
    public static String updateUser() {
        return "update user set name = ?, gender = ?, password = ?, phone = ?, role = ? where stucode = ?";
    }
    public static String insertUser() {
        return "insert into user(stucode, name, gender, password, phone, rooms_card, buildings_card, role) values(?, ?, ?, ?, ?, ?, ?, 0)";
    }
}
